Tabela OccupationalMedDecision

Definicja tabeli OccupationalMedDecision

Name

OccupationalMedDecision

Code

OccupationalMedDecision

Comment

Zadaniem tebli jest przechowywanie inf. o orzeczeniach wydanych dla pacjenta.


Lista kolumn tabeli OccupationalMedDecision

Name

Code

OccupationalMedDecisionID

OccupationalMedDecisionID

EventID

EventID

PerfDT

PerfDT

Decision

Decision

StopDT

StopDT

Active

Active

FormInstanceID

FormInstanceID

PersonID

PersonID

Revocation

Revocation

RevocationDT

RevocationDT

RevocationReason

RevocationReason

Comments

Comments


Kolumna OccupationalMedDecisionID tabeli OccupationalMedDecision

Definicja kolumny OccupationalMedDecisionID tabeli OccupationalMedDecision

Name

OccupationalMedDecisionID

Code

OccupationalMedDecisionID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna EventID tabeli OccupationalMedDecision

Definicja kolumny EventID tabeli OccupationalMedDecision

Name

EventID

Code

EventID

Data Type

NUMBER(10)

Mandatory

No

Comment

pobyt/wizyta (tabela Event)


Kolumna PerfDT tabeli OccupationalMedDecision

Definicja kolumny PerfDT tabeli OccupationalMedDecision

Name

PerfDT

Code

PerfDT

Data Type

DATE

Mandatory

No

Comment

data wykonania/wprowadzenia orzeczenia


Kolumna Decision tabeli OccupationalMedDecision

Definicja kolumny Decision tabeli OccupationalMedDecision

Name

Decision

Code

Decision

Data Type

NUMBER(10)

Mandatory

No

Comment

decyzja 1-pozytywna, 0-negatywna, byc moze w przyszlosci beda inne rodzaje


Kolumna StopDT tabeli OccupationalMedDecision

Definicja kolumny StopDT tabeli OccupationalMedDecision

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

data obowiazywania


Kolumna Active tabeli OccupationalMedDecision

Definicja kolumny Active tabeli OccupationalMedDecision

Name

Active

Code

Active

Data Type

NUMBER(10)

Mandatory

No

Comment

aktywnosc


Kolumna FormInstanceID tabeli OccupationalMedDecision

Definicja kolumny FormInstanceID tabeli OccupationalMedDecision

Name

FormInstanceID

Code

FormInstanceID

Data Type

NUMBER(10)

Mandatory

No

Comment

spiety z orzeczeniem formularz (typ orzeczenia)


Kolumna PersonID tabeli OccupationalMedDecision

Definicja kolumny PersonID tabeli OccupationalMedDecision

Name

PersonID

Code

PersonID

Data Type

NUMBER(10)

Mandatory

No

Comment

pole przechowujace lekarza z pobytu/wizyty


Kolumna Revocation tabeli OccupationalMedDecision

Definicja kolumny Revocation tabeli OccupationalMedDecision

Name

Revocation

Code

Revocation

Data Type

NUMBER(10)

Mandatory

No

Comment

pole oznacza ze mialo miejsce odwolanie od decyzji lekarza (pacjent sie
odwowal)


Kolumna RevocationDT tabeli OccupationalMedDecision

Definicja kolumny RevocationDT tabeli OccupationalMedDecision

Name

RevocationDT

Code

RevocationDT

Data Type

DATE

Mandatory

No

Comment

data dodania odwolania


Kolumna RevocationReason tabeli OccupationalMedDecision

Definicja kolumny RevocationReason tabeli OccupationalMedDecision

Name

RevocationReason

Code

RevocationReason

Data Type

VARCHAR2(255)

Mandatory

No

Comment

powód odwolania


Kolumna Comments tabeli OccupationalMedDecision

Definicja kolumny Comments tabeli OccupationalMedDecision

Name

Comments

Code

Comments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

komentarz do orzeczenia


Lista kluczy tabeli OccupationalMedDecision

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli OccupationalMedDecision

Definicja klucza Identifier_1 tabeli OccupationalMedDecision

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment